The analysis in the report is regarding building certification lodgements in the Townsville local government area. Townsville is a city and a major port area in eastern Queensland, Australia. Two data sets have been combined and used for the analysis from the www.data.gov.au website.
First data set i.e. the building approval details have been extracted from here and includes number of building approvals from 2009 to 2021 and their corresponding details e.g. Decision, Class, Suburb etc. And the second data set i.e. City of Townsville’s Suburb geometry has been extracted from here and includes the geometrical values for these Suburbs.
Project Details
Name: Analyzing Building approvals data for the City of Townsville (Assignment 4, ETC5513)
Objective: Answering research questions regarding Year, Approvals, Class, Category, Suburb and Estimated Cost for Building Approvals in the city of Townsville.
Research Questions
To identify the year with maximum approvals and to analyze the data further to find out the suburb and estimate cost of building with respect to the most popular class in that year. And also find out the category that is most in demand for that class.
To analyze the suburb which was inferred from research question 1 and find out the year for which it had the maximum approvals. Also find out the class that occurred maximum times, category with respect to that class and estimate cost for these particular variables.
Variable Information and Explanation
| Application Type |
| Date Of Decision Notice |
| Decision |
| Class |
| Subcategory |
| Category |
| Estimated Cost |
| Suburb |
| Floor Area |
| No Of Units |
| Electoral Division |
| Latitude |
| Longitude |
Below is the description of the variables used in the dataset:
Application type: Here, application for ‘building certification lodgements’.
Date of decision notice: The date the building certifier made a notice that the works met the building codes.
Decision: Current status of the works as recorded with Council.
Class: The building classification as per the list on page one.
Sub-category (Council category descriptors): This category is a subdivision of class. Provides information regarding additions, alterations, subdwell etc in it.
Category: Townsville City Council has published on its website for a number of years a summary of building approval data using the certain categories.
Estimated values: The monetary value of the proposed building work.
Suburb: The suburb where the building work is taking place.
Floor area: The floor area of the building works in square metres.
No. of units: Number of individual units created or demolished by the building works.
Electoral Division: The local government electoral division in which the works are occurring.
Latitude and Longitude: Geometry dimensions
Answering Research Question 1
| Year | Class | Count_of_Class |
|---|---|---|
| 2020 | Class 1a | 406 |
| 2020 | Class 10a | 275 |
| 2020 | Class 10b | 154 |
| 2020 | Class 6 | 25 |
| 2020 | Class 5 | 13 |
| 2020 | Class 9b | 13 |
In the figure 1.1 the year 2020 has maximum approvals till now.
In figure 1.2 using plotly, we observe that Class 1a occurs in maximum suburbs.
Table:1.3 gives us the total count of Class 1a. It shows that Class 1a has the maximum count out of all the other classes.
Class 1a includes :Single dwelling, detached house, town house or villa unit.
| x |
|---|
| 993644 |
| x |
|---|
| 1074668 |
| x |
|---|
| 2068312 |
Answering Research Question 2: Finding Year and class that occurs most no. of times for approved projects in Kirwan and Hermit Park, in 2021 and 2020 respectively.
| Year | Class | Suburb | Decision | Class_count |
|---|---|---|---|---|
| 2021 | Class 10a | Kirwan | #Approved | 31 |
| 2021 | Class 1a | Kirwan | #Approved | 13 |
| 2021 | Class 10b | Kirwan | #Approved | 8 |
| 2021 | Class 5 | Kirwan | #Approved | 2 |
| 2021 | Class 6 | Kirwan | #Approved | 1 |
| 2021 | Class 9b | Kirwan | #Approved | 1 |
| Year | Class | Suburb | Decision | Class_count |
|---|---|---|---|---|
| 2020 | Class 1a | Hermit Park | #Approved | 18 |
| 2020 | Class 10a | Hermit Park | #Approved | 4 |
| 2020 | Class 10b | Hermit Park | #Approved | 3 |
A. Out of Class 10a and Class 1a, finding category that is most in demand for approved projects in Kirwan(2020) and Hermit Park(2021) respectively. B. (Keeping, ‘Decision as Approved’, ‘Category as Residential-Other’,‘Suburbs as Kirwan and Hermit Park’,constant. Keeping ‘Year as 2021’ and ‘Class as 10a’ constant for Kirwan. Keeping ‘Year as 2020’ and ‘Class as 1a’ constant for Hermit Park.)
| x |
|---|
| 511371 |
| x |
|---|
| 1074668 |
It is evident from both the graphs that the Residential-Other category for approved projects, is in demand for both suburbs and both classes in their respective years.
By observing table, we know that the total cost for suburb Kirwan for class 10a approved projects(Residential-Other category) in 2020 is $511,371.
And from, we know that the total cost for suburb Hermit Park for class 1a approved projects(Residential-Other category) in 2021 is $1,074,668.
Here, we observe that, all the components for Hermit Park are common between flowchart and flowchart. In both the flowcharts, best (maximum approvals) year 2020, project Class 1a, category residential-other and cost $1,074,668 are common.
We can say that, for research question 2, Part B: the reverse Analysis for result 1 has been successful
Although, out of the approvals that took place in the year 2020 (best year with maximum approvals), maximum approvals were of Kirwan, but this has not been the case vice-versa and hence there is not much similarity between result 1 and result 2(PartA).
For result 1 and result 2(Part B), both the flowcharts are depicting the reverse of each other, giving the same information.
Credits :
Pranali angne (32355068)
Nishtha arora (32296622)
Raunak bhivpathaki (32230486)
[1] D. Kahle and H. Wickham. ggmap: Spatial Visualization with ggplot2. The R Journal, 5(1), 144-161. URL http://journal.r-project.org/archive/2013-1/kahle-wickham.pdf
[2] Original S code by Richard A. Becker, Allan R. Wilks. R version by Ray Brownrigg. Enhancements by Thomas P Minka and Alex Deckmyn. (2018). maps: Draw Geographical Maps. R package version 3.3.0. https://CRAN.R-project.org/package=maps
[3] Hao Zhu (2021). kableExtra: Construct Complex Table with ‘kable’ and Pipe Syntax. R package version 1.3.4. https://CRAN.R-project.org/package=kableExtra
[4] Hadley Wickham and Jim Hester (2020). readr: Read Rectangular Text Data. R package version 1.4.0. https://CRAN.R-project.org/package=readr
[5] C. Sievert. Interactive Web-Based Data Visualization with R, plotly, and shiny. Chapman and Hall/CRC Florida, 2020.
[6] Wickham et al., (2019). Welcome to the tidyverse. Journal of Open Source Software, 4(43), 1686, https://doi.org/10.21105/joss.01686
[7] Garrett Grolemund, Hadley Wickham (2011). Dates and Times Made Easy with lubridate. Journal of Statistical Software, 40(3), 1-25. URL https://www.jstatsoft.org/v40/i03/.
[8] H. Wickham. ggplot2: Elegant Graphics for Data Analysis. Springer-Verlag New York, 2016.
[9] Erich Neuwirth (2014). RColorBrewer: ColorBrewer Palettes. R package version 1.1-2. https://CRAN.R-project.org/package=RColorBrewer
[10] Ron Ammar (2019). randomcoloR: Generate Attractive Random Colors. R package version 1.1.0.1. https://CRAN.R-project.org/package=randomcoloR
[11] Jennifer Bryan (2017). gapminder: Data from Gapminder. R package version 0.3.0. https://CRAN.R-project.org/package=gapminder
[12] Karthik Ram and Hadley Wickham (2018). wesanderson: A Wes Anderson Palette Generator. R package version 0.3.6. https://CRAN.R-project.org/package=wesanderson
[13 Townsville City Council Building Approvals - data.gov.au. (2021). Retrieved 2 June 2021, from https://data.gov.au/data/dataset/tcc-building-approvals
[14] Townsville Suburbs - data.gov.au. (2021). Retrieved 2 June 2021, from https://data.gov.au/dataset/ds-dga-81cbbedc-e35f-4266-980d-21a6159b2404/distribution/dist-dga-28812258-4cf4-46aa-aa43-0206d7c60920/details?q=
[15] RStudio Team (2020). RStudio: Integrated Development for R. RStudio, PBC, Boston, MA URL http://www.rstudio.com/.
[16] GitHub: Where the world builds software. (2021). Retrieved 2 June 2021, from https://github.com/
[17] GitKraken Documentation. (2021). Retrieved 2 June 2021, from https://support.gitkraken.com/start-here/guide/
[18] A hackable text editor for the 21st Century. (2021). Retrieved 2 June 2021, from https://atom.io
[19] Azyyati Marzukhi, M., Jaafar, A. and Ling Hoon Leh, O., 2019. The Effectiveness Of Building Plan Approval. Case Study: Subang Jaya Municipal Council, Selangor. [online] Malaysia. Available at: https://www.matec-conferences.org/articles/matecconf/pdf/2019/15/matecconf_iconbee2019_06005.pdf [Accessed 2 June 2021].